UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nFkbGApuhl5WanNfQP28mq093RJmYXz0+Gs1H/LHgtA='
WHERE
key_id = '64cce1d83a1d893cff7a297ab7945b12777432c369f0abe33c881837aad5f26c'
AND (
token = 'nFkbGApuhl5WanNfQP28mq093RJmYXz0+Gs1H/LHgtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)