UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oOM66RZMHinAiHQZ8ifpAChoNd2Q08YW6gzIvgnmRiI='
WHERE
key_id = 'aa345478e2e1e199af485af880359d56e98ce84ececee1aa9cbf998d724d9ed8'
AND (
token = 'oOM66RZMHinAiHQZ8ifpAChoNd2Q08YW6gzIvgnmRiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)