UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wpgoEW+I6k1ouV+w3/7ub+Uu0msXp5iISDg7AmarOwg=' 
WHERE 
  key_id = 'b5a9815a13a2cfcc4485c5f2875f3ba43b3f8494e5dbef85e6c9b7c5f046ea53' 
  AND (
    token = 'wpgoEW+I6k1ouV+w3/7ub+Uu0msXp5iISDg7AmarOwg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016