UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uaAkUeFjAJnvABYxtyEtrFfzwxH789kfuwmv7mUkVoc='
WHERE
key_id = '1528c83d7a9c0a6c35811b94fd2f882cca7adcb54a477741e66e6dc80a3ad2e6'
AND (
token = 'uaAkUeFjAJnvABYxtyEtrFfzwxH789kfuwmv7mUkVoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)