CREATE TABLE IF NOT EXISTS `user_etokens` (
  `id` bigint(14) NOT NULL,
  `user_id` bigint(14) NOT NULL,
  `email` varchar(255) NOT NULL,
  `code` int(10) NOT NULL,
  `etoken` char(64) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `etoken` (`etoken`),
  KEY `created` (`created`),
  KEY `email` (`email`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

MariaDB [dating]> explain SELECT * FROM `user_etokens` WHERE `created` < DATE_SUB(NOW() , INTERVAL 1 MONTH);
+------+-------------+--------------+------+---------------+------+---------+------+---------+-------------+
| id   | select_type | table        | type | possible_keys | key  | key_len | ref  | rows    | Extra       |
+------+-------------+--------------+------+---------------+------+---------+------+---------+-------------+
|    1 | SIMPLE      | user_etokens | ALL  | created       | NULL | NULL    | NULL | 1253259 | Using where |
+------+-------------+--------------+------+---------------+------+---------+------+---------+-------------+
1 row in set (0.00 sec)