UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S7qKHmEVdS8oeSwjHwSI8CHb56n3FuyiHq8xYUy0t5M='
WHERE
key_id = 'b883ade0424c49a697fd3cea6754d5c2b3c36ca1574835f3d64fbf4861bf8ef4'
AND (
token = 'S7qKHmEVdS8oeSwjHwSI8CHb56n3FuyiHq8xYUy0t5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)