UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YBCsjayGshgEd8ZC1VbtLUqxfFgRhfTM32N/DtGuIzg='
WHERE
key_id = 'f0fdec16d9124a64b3a255322ba2c26d6bcaa87f2aa8d235d68c19cff7ce8966'
AND (
token = 'YBCsjayGshgEd8ZC1VbtLUqxfFgRhfTM32N/DtGuIzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)