UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FLFS7tXyw41dMR0lLtL6f1ppLaY/qUT1N24XGUcWw1c='
WHERE
key_id = 'ca9042afc654c1f085439c5409f7e87f26918f1944d6d6355841c199c7049812'
AND (
token = 'FLFS7tXyw41dMR0lLtL6f1ppLaY/qUT1N24XGUcWw1c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)