UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SCFapi5Ft8aCBG4WUUjJLnOm4acy8OnVHwoe9krGilc=' 
WHERE 
  key_id = '51bbc60076f6fb253b7807de6a0509ba4a98916e337a9fa3decad8c9bebf23ed' 
  AND (
    token = 'SCFapi5Ft8aCBG4WUUjJLnOm4acy8OnVHwoe9krGilc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032