Sql cross table update

See more:

MySQL

I use a mysql 5.7 database.

I want to create a job that automatically subtracts the money for the rented cars from a player's wallet.

I got a problem with updating the players amount of money for it's rented car(s). Only the costs for the first car, the join throws back is subtracted. Is a cross table update the right way to do it or do i need a loop?

What I have tried:

UPDATE player p 
JOIN garage g ON p.id = garage.owner 
JOIN car c ON c.id = garage.car
SET p.money = p.money - c.rentrate, g.lastpaidrent = NOW()
WHERE c.rented = '1' AND TIMESTAMPDIFF(HOUR, c.lastpaidrent, NOW()) >= 24 AND p.money >= c.rentrate