UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HHP/9d1bG4pkRJcSVTGfZLvTwkeiHNeXx/9u2yidAU8='
WHERE
key_id = '4dca99646b85d48ee34212d83b0f76546921a636849fce4798829616e7075847'
AND (
token = 'HHP/9d1bG4pkRJcSVTGfZLvTwkeiHNeXx/9u2yidAU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)