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