UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cT4zgSa4GAd85l1cEakerMABiy3lGDHTeP6OHh54BMc='
WHERE
key_id = '21aa242b006487cca619158985b25923c8b12dca9a6704625320b76dd70224ea'
AND (
token = 'cT4zgSa4GAd85l1cEakerMABiy3lGDHTeP6OHh54BMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)