UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Jn0ElKcxl5fSXT8fx8DYhVUdy+Qph4+CzgXvIiLTuU='
WHERE
key_id = '26644cd1671edc2b03dd47c107901e4dac24f03eeaa5322e9f57e3ddef4a4aff'
AND (
token = '4Jn0ElKcxl5fSXT8fx8DYhVUdy+Qph4+CzgXvIiLTuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)