[localhost]:mysql> explain account;
+---------------+------------------+------+-----+-------------------+-----------------------------+
| Field         | Type             | Null | Key | Default           | Extra                       |
+---------------+------------------+------+-----+-------------------+-----------------------------+

[redacted]

| created_on    | timestamp        | NO   |     | CURRENT_TIMESTAMP |                             |
| modified_on   | timestamp        | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+---------------+------------------+------+-----+-------------------+-----------------------------+
9 rows in set (0.00 sec)

[localhost]:mysql> select count(account_id) from account;
+-------------------+
| count(account_id) |
+-------------------+
|                66 |
+-------------------+
1 row in set (0.00 sec)

[localhost]:mysql> select count(account_id) from account where datediff(now(), modified_on) >= 1;
+-------------------+
| count(account_id) |
+-------------------+
|                42 |
+-------------------+
1 row in set (0.00 sec)