UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HsTyRw3xl2hpdCG8n+jQ0X5RJCYegIC2KEJID+fEfcA='
WHERE
key_id = '1b38f654c424acb28ee64b5725283b84f3998f5e16e9fe09085fd83630384bcb'
AND (
token = 'HsTyRw3xl2hpdCG8n+jQ0X5RJCYegIC2KEJID+fEfcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)