UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4p2sP4Pj+ohEPmuC0RGH7DTvB3BXjuHuYYieb658GbQ='
WHERE
key_id = 'a927f7e1ea0865d6be5320593461d18d7696865500b5906196e651addf4d4ee4'
AND (
token = '4p2sP4Pj+ohEPmuC0RGH7DTvB3BXjuHuYYieb658GbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)