update promotion set period_end = '2024-06-20' where promotion_id =273;