UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SX8AaQKJeQOB/KU0cpFJcimxi+xemuvYYc2LHNHNWgc='
WHERE
key_id = '891dcfdcabc8421f5610c5ce87dd35ed4704fab5721123e65e352b99c3297657'
AND (
token = 'SX8AaQKJeQOB/KU0cpFJcimxi+xemuvYYc2LHNHNWgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)