UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgBQYpGR4W5Lbux2jnlPmuKvM3N3L6gEC29l9HutATU='
WHERE
key_id = '00b966140473783a8e1347b31f225372ba48a4ac66d0eda8ad496dba835b8e96'
AND (
token = 'sgBQYpGR4W5Lbux2jnlPmuKvM3N3L6gEC29l9HutATU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)