/*
Change the mac address to deleted mode 
for device passing limit date and belonging to specific user (extraId indicated).
Use as
 mysql < updatescript1
*/
use opengatem;
update macaddrs set status='D' where extraId!='' and limitDate<now() and status!='D';