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