MySQL table that Checks two variables in one table but does changes in multiple tables

I've been cracking my head around trying to make an if statement that will check the values of one table. Of course, this one checking an ID and an Amount. Based on the results I want it to execute an action in two tables. One, being itself as it will empty the amount in this table, and the other being a completely different table that has to increase the amount.

I'm trying to make an if statement that will take the "Amount" from the first table, and add it as the Timer on the second table. As well as empty out the amount from the first table. I've been cracking my head left and right trying to solve this studying numerous if and else statements but I've had no luck figuring it out. If anyone can help?

So basically, I have two tables containing (in simple words):

id - name - amount - purpose

id - location - timer - purpose