There is currently no automation available for changing the status when the expiry date is passed. The only way to do it is via a bulk update.