Update shipment status for missed pickups, log event in shipment history

Update shipment statuses in MySQL when pickups are missed, and log these events for better tracking. This ensures accurate shipment history and improves operational efficiency.