Lampard has been out of work since leaving Chelsea in May 2023