UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9G735b0yTtI/RLN4eQe3HMDjbLwz/QAnoBLc0cEs1M='
WHERE
key_id = '47d6d6b5a1afe3cc9b208de9cdd8715e55411cf8f37f1375c4e954670bd52aff'
AND (
token = 'E9G735b0yTtI/RLN4eQe3HMDjbLwz/QAnoBLc0cEs1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)