UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '92xg7Vg7gQuXRKbe8iX0IFt/l2GibeAkcV34zcoVyIU='
WHERE
key_id = '8a872c417b31a05e8071478559da528d06e4b9f5cd55d825b4a0678319fcfb40'
AND (
token = '92xg7Vg7gQuXRKbe8iX0IFt/l2GibeAkcV34zcoVyIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)