UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qe3sX4fPWlfW0noUhOp43ZWnkj9jz7/0pcKUdMR/4lQ='
WHERE
key_id = 'd0eae7071207a6690d4a9892aed82a5cefff081d4933532debb051aebf0a937a'
AND (
token = 'qe3sX4fPWlfW0noUhOp43ZWnkj9jz7/0pcKUdMR/4lQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)