UPDATE `casemgmt_note` SET `signed`=1, `update_date`=CURDATE(),`signing_provider_no`="000000" WHERE `signed`=0 AND `observation_date` <= DATE_SUB(NOW(), INTERVAL 1 MONTH) AND `update_date`=`observation_date`