mysql procedure between two tables

11. SET GLOBAL event_scheduler=ON
22. CREATE EVENT update_status_event
3    ON SCHEDULE
4      EVERY 1 DAY
5ON COMPLETION NOT PRESERVE ENABLE
6    COMMENT 'Suspend Phone Service If Remaining Days < 0'
7    DO
8       UPDATE phone_services p, user_settings u SET p.phone_service_status = 2, u.is_app_enabled=0, u.device_identifier='' WHERE p.phone_service_device <> 'GP' AND p.remaining_days <= 0;