UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foD6Mw7cefjGIhpPzrq2jf1pfX8l8kHGqUqApoxaA8k='
WHERE
key_id = '61d7cf9547f920ae1ec2439936a47cdebb7e022a2fea718c50698ee85846a6bf'
AND (
token = 'foD6Mw7cefjGIhpPzrq2jf1pfX8l8kHGqUqApoxaA8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)