UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/7e0DrSgKLCZmdJQeDs/yo4YYWXGzIGuA0iR1pqT09w=' 
WHERE 
  key_id = '175c0b3317b8900d6648a7e7b84afb22acd38f7dc21d1b16a5e1db4e4ea85129' 
  AND (
    token = '/7e0DrSgKLCZmdJQeDs/yo4YYWXGzIGuA0iR1pqT09w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025