UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPovtZIKzt7YhpUWacbm8pAb58D20GAi+pUnMhxWuFE='
WHERE
key_id = '246b499056005b56f05fa6aaa8a2c9f48f12d8917aaea609bcfd13ea4ba2ea3e'
AND (
token = 'tPovtZIKzt7YhpUWacbm8pAb58D20GAi+pUnMhxWuFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)