UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9iwQywL/WsnVePd8IoUYHIuU+SCPCtvL/BtVzkOw5m4='
WHERE
key_id = 'ebedb49abbb3abba438fd326a15ff7749550abb80fe7c5005e1c3cf1ee5a203b'
AND (
token = '9iwQywL/WsnVePd8IoUYHIuU+SCPCtvL/BtVzkOw5m4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)