updating the subscription status completion information in the database after successful payment