UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7kZt/NZ7mdp6eXUV97UiGUB9X9Ga3CfxphHuo+fFdMY='
WHERE
key_id = '3687d977ffeaf94395590521f6efc907459ae9ed06a8a9de36e6727e1b26537a'
AND (
token = '7kZt/NZ7mdp6eXUV97UiGUB9X9Ga3CfxphHuo+fFdMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)