DELETE FROM table WHERE `date` < DATE_SUB(NOW(), INTERVAL 30 DAY);