UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9uwbSsuSaI/1ggeoD3pfKJ01nVHEcWzY0j7ZxKZI5g='
WHERE
key_id = 'f29323e83c222d7f7ce001a21d90fb62eb2ccc542fd1f9f7734feb11d23eee74'
AND (
token = 'X9uwbSsuSaI/1ggeoD3pfKJ01nVHEcWzY0j7ZxKZI5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)