UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1pnxEhOeRb1hcFW/WlV8bODYfFm1v+iTuu8o1TxRLZ0='
WHERE
key_id = 'f754793248ac22408c6d4df9a65ee690d8adedf96724490f536e8479c181d986'
AND (
token = '1pnxEhOeRb1hcFW/WlV8bODYfFm1v+iTuu8o1TxRLZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)