UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lh7aeqjtrRtmo1FYxHQ3Nw8U4qKQXuYBuVxdo8Odte8='
WHERE
key_id = '16814a715d3a7ae7ff71b72780a42292b553d5df59b76f4327c96a3b2f755959'
AND (
token = 'Lh7aeqjtrRtmo1FYxHQ3Nw8U4qKQXuYBuVxdo8Odte8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)