UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3W1Fj6D3ALQToYm8IISN+rEwhWFhFFHgS1lyUMxdvpY='
WHERE
key_id = '31f9ec2cf72f2b34b6c6eab52d457e07304a0b0c0faa86bfd52c4f92b826565a'
AND (
token = '3W1Fj6D3ALQToYm8IISN+rEwhWFhFFHgS1lyUMxdvpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)