UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRV0AzaU0brrAsIH32iZfITRnI2zbDB5CyogA21/kQM='
WHERE
key_id = 'a1aaf111effbbf360804c995a76b16900a14b9ca96d1be6008bac36acd206b09'
AND (
token = 'HRV0AzaU0brrAsIH32iZfITRnI2zbDB5CyogA21/kQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)