UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aXkNu3lTEyR6uI3/B2rIC0msNZlQOmfB7YmtAiEFsAI='
WHERE
key_id = '1d6a8ce4e89bb8a858a6bf9d67cb644a1e8b4b509aa6d0e4d9b7cd102b2766c0'
AND (
token = 'aXkNu3lTEyR6uI3/B2rIC0msNZlQOmfB7YmtAiEFsAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)