UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6ULS1yHhj5aycpRLFbNAkroIktQ3CIqvKhof+OAE/oI=' 
WHERE 
  key_id = 'cc9096018abd9b77284e3f8b1e898b95ae20aac9c5f081dd98634b976e5fda61' 
  AND (
    token = '6ULS1yHhj5aycpRLFbNAkroIktQ3CIqvKhof+OAE/oI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )