UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QRe8c9bKSTaXipQylGXb8r4yYhG1gNdEaZSxfaRoEfA='
WHERE
key_id = '7c4944ca31e1df601e69de820e3fd90799417ce55650a2c26c1b44eea0275611'
AND (
token = 'QRe8c9bKSTaXipQylGXb8r4yYhG1gNdEaZSxfaRoEfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)