UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nIenkINgNPdKGPWIL9Cca8BbkbJU0MCiwSY7ALHijUo='
WHERE
key_id = '762d63a0ae8773f3265b3a9b73c0c8e601246b172fa062b6fc72fd4e09f0f505'
AND (
token = 'nIenkINgNPdKGPWIL9Cca8BbkbJU0MCiwSY7ALHijUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)