UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Hks3hnVERaYwXJsUXo2JolP45yC2+RS7R/+NfGCAeU='
WHERE
key_id = '3139cf26022160d61fe7e0bb81eaa69c4954a4074909b4bb0d14ba277cf3ad1a'
AND (
token = '9Hks3hnVERaYwXJsUXo2JolP45yC2+RS7R/+NfGCAeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)