UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RcyawyzC3F0PI+K0AYTLXIJyvaoVwiiEZQrLn35uKpo='
WHERE
key_id = 'ce98d25b3ede9c041f1a574225e4b8d7626d388c18f6f8e150220f187ce3ca35'
AND (
token = 'RcyawyzC3F0PI+K0AYTLXIJyvaoVwiiEZQrLn35uKpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)