UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'G9ZWqmfDMU+D0AmPP+41i4esXr2sAqjf+5bUOjB4uZw=' 
WHERE 
  key_id = 'ad42b058cb5df35a8856e05c318cadfd4f3429b87f666064db4b7aff07ac5b77' 
  AND (
    token = 'G9ZWqmfDMU+D0AmPP+41i4esXr2sAqjf+5bUOjB4uZw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )