How to automatically update an entry daily in phpMyAdmin?

I have a database called ARTICLES. Inside Articles, I have a table called Users. Inside Users, there is an entry called Renewal. Renewal will be set at an Integer. Once Renewal is set, it should decrease by 1 every 24 hours. For example, let's say Renewal is 30. In 24 hours, Renewal should be 29. I do not wish to go inside the entry, and update this field every 24 hours. There will be hundreds of rows with different values for Renewal.

Is there a way to automatically update this entry every 24 hours, so that the entry decreases by 1?