Automatization on subscription plan change

I have an online school with subscription plans. If any student desire to change their plan, we can easily change from web, but the old plan must be cancelled or set to expired via SQL. 

Can you please implement a way to automatize this process?

Thanks