UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3FaSKXv5QS4PccO4DQ1UgWdheFC86A37ICKZQbOJ1l0='
WHERE
key_id = 'bf3c2a7ce87b978ad0d459302f2b249288363c1b3c43ff9de6923457f36d1032'
AND (
token = '3FaSKXv5QS4PccO4DQ1UgWdheFC86A37ICKZQbOJ1l0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)