UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ut10Ovq9RY854vsznrJ+zvlV9+pZlGtU79MEzYlz7C0='
WHERE
key_id = '63f2fd24f90fa7952bd58d84f23ab1ddc13b60e7e9689866922eecc29e141d2b'
AND (
token = 'ut10Ovq9RY854vsznrJ+zvlV9+pZlGtU79MEzYlz7C0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)