UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MhZPA5f2c5ltz/ZPgoGoP7EDGoNJuP2tcHdQ1OhDM3g=' 
WHERE 
  key_id = 'b7ffa7d71b98f7646b45866e5cd1213b1dd011d26212ec426e705aaf5b34d800' 
  AND (
    token = 'MhZPA5f2c5ltz/ZPgoGoP7EDGoNJuP2tcHdQ1OhDM3g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )