SELECT JSON_OBJECT('mac',id,'meta',name) FROM `mj_devices` WHERE last_access <= DATE_SUB(NOW(), interval period second)