UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+OAi4woeD6AyXAW4u/cjJu9BSNPdzx/0GcUaRtbdJbw='
WHERE
key_id = '96494f3cd8330adc297ff59916decef2c490c211724f4bbfaa242eb74b6defee'
AND (
token = '+OAi4woeD6AyXAW4u/cjJu9BSNPdzx/0GcUaRtbdJbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)