UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dCbVynmaduirpEjq7vT93ZFMysqg/26gBmdEkdp17zM='
WHERE
key_id = 'fb106632342398966a2e778e65572cc976afffe4c3bf1069e15a7aab7d6a21fb'
AND (
token = 'dCbVynmaduirpEjq7vT93ZFMysqg/26gBmdEkdp17zM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)