UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QJE9J75JtfvOYVSo4p2mmjPoMCVZyxdw7D0nJai0jS4='
WHERE
key_id = '54954369ff695f1dae71855189592f1eb87cbed32d89fc286fe66b05ae1675f4'
AND (
token = 'QJE9J75JtfvOYVSo4p2mmjPoMCVZyxdw7D0nJai0jS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)