UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vjn+OlUABy3BhYV1G/ElLYYfDZh3C1dfdvPVnB4oGSw='
WHERE
key_id = '7afe652eb8acd6849043075eb1db99a17d0af68f764b6a8c42b6677cb9ebd091'
AND (
token = 'Vjn+OlUABy3BhYV1G/ElLYYfDZh3C1dfdvPVnB4oGSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)