UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZEsNP3IijdQ5mP9Zjzo2EEYkgCjM8zSEdJO/swvGL8I='
WHERE
key_id = 'e73b7764f0a6af8261024c7b0127492a6d7b47c969acb8aede1ac17e8802a897'
AND (
token = 'ZEsNP3IijdQ5mP9Zjzo2EEYkgCjM8zSEdJO/swvGL8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)