How to use MYSQL with Case or IF

Question

This is with CASE that does not work, the idea is simple every day the training of the players is reset to 15, IF the player is VIP, that is to say "time VIP" LESS than the current date, he has only 15 Practices, if not he would be 25, I tried his ways with Case (did not work) If (Also not), someone knows how to make it work?

UPDATE `_personagens` SET `treinos_restantes`= CASE WHEN (tempoVip<CURRENT_TIMESTAMP) THEN "15" ELSE "25" END

UPDATE `_personagens` SET `treinos_restantes`=IF((tempoVip<CURRENT_TIMESTAMP), 15, 25) WHERE Id>0

Answer 1

The UPDATE can be used with WHERE.

UPDATE `_personagens` SET `treinos_restantes` = "XX" WHERE CURRENT_TIMESTAMP() >= `tempoVip`;
UPDATE `_personagens` SET `treinos_restantes` = "XX" WHERE CURRENT_TIMESTAMP() <= `tempoVip`;