UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKYCdcgdYjhsM/9vAlT6w3Zg7pD1OPxR1UzNudUnICw='
WHERE
key_id = 'a189ecc3588a1df9a42c946788b8437b9f0964f4ca5178d767ec289277d48595'
AND (
token = 'nKYCdcgdYjhsM/9vAlT6w3Zg7pD1OPxR1UzNudUnICw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)