UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4SuNycJQ3J+OmksjZ6rMu7ovh3PjJnU1X+6lRCkY940=' 
WHERE 
  key_id = '0078f1d70fb31fa891b1ec3ec770697fbccf30c31fcbf2aee685acd4eec2f643' 
  AND (
    token = '4SuNycJQ3J+OmksjZ6rMu7ovh3PjJnU1X+6lRCkY940=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )