delete row from unconfirmed_subscribers table upon confirmation.