UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9H9PBxfwIHx0cte2nFVsTuxumMCWgJjNB4NMkPrWqs='
WHERE
key_id = '0845278a51148d4ee271ffee4bb5386aeb779fbc96902f23e6eed286fc27f045'
AND (
token = 'z9H9PBxfwIHx0cte2nFVsTuxumMCWgJjNB4NMkPrWqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)