UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LqxDjOMYueSEjjWcvabWQ+cDr34+mig1AJgmwHu0P84='
WHERE
key_id = 'f1a24fdc7f4e8f601becf1c1214fa95bfed150f8492a978542910a165279d39c'
AND (
token = 'LqxDjOMYueSEjjWcvabWQ+cDr34+mig1AJgmwHu0P84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)