mysql> DELETE FROM tbl_name 
           WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) > 31;